Cannot search all sheets in a workbook at once due to sheets not selected.
Cause:
This problem occurs because the sheets are not selected at the same time.
Solution:
Select all sheets in the workbook at the same time.
1) Click the tab for the first sheet.
2) Press and hold down SHIFT and click the tab for the last sheet.
